﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="SSFGLList.aspx.cs" Inherits="SSFGL_SSFGLList" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@ Register Assembly="DevExpress.Web.ASPxEditors.v12.1, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
  Namespace="DevExpress.Web.ASPxEditors" TagPrefix="dxe" %>
<%@ Register Assembly="DevExpress.Web.ASPxGridView.v12.1, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
  Namespace="DevExpress.Web.ASPxGridView" TagPrefix="dxwgv" %>
<%@ Register Assembly="DevExpress.Web.ASPxGridView.v12.1.Export, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
  Namespace="DevExpress.Web.ASPxGridView.Export" TagPrefix="dxwgv" %>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
  <title>抄表用户收费管理</title>
  <script src="../submodal/common.js" type="text/javascript"></script>
  <link href="../submodal/subModal.css" rel="stylesheet" type="text/css" />
  <link href="../submodal/style.css" rel="stylesheet" type="text/css" />
  <script src="../submodal/subModal.js" type="text/javascript"></script>
  <%-- <style type="text/css">
    body
    {
      color: #000;
      background-color: #EEF2FB;
      margin: 0px;
      font-family: "宋体";
      font-size: 12px;
    }
  </style>--%>
  <script language="JavaScript">

    function returnRefresh(returnVal) {
        // document.forms["aspnetForm"].submit();
//        alert(returnVal);
      if (returnVal != null) {
        var a = returnVal.split("_");
        if (a[2] == 1)
          window.location.href = "SSFGLAdd.aspx?jfsjid=" + a[1] + "&khid=" + a[0];
        else
          alert("密码不正确");
      }
    }
    function create2(khid, jfsjid) {
      showPopWin("收费回退密码", "SFMM.aspx?khid=" + khid + "&JFSJID=" + jfsjid, 400, 200, returnRefresh, true, true);
    }
  </script>
  <link href="../css/main.css" rel="stylesheet" type="text/css" />
</head>
<body>
  <form id="form1" runat="server">
  <table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#EEF2FB">
    <%-- <tr>
      <td width="17" valign="top" background="../images/mail_leftbg.gif">
        <img src="../images/left-top-right.gif" width="17" height="29" />
      </td>
      <td valign="top" background="../images/content-bg.gif">
        <table width="100%" height="31" border="0" cellpadding="0" cellspacing="0" class="left_topbg"
          id="table2">
          <tr>
            <td height="31">
              <div class="titlebt">
                缴费记录</div>
            </td>
          </tr>
        </table>
      </td>
      <td width="16" valign="top" background="../images/mail_rightbg.gif">
        <img src="../images/nav-right-bg.gif" width="16" height="29" />
      </td>
    </tr>--%>
    <tr>
      <%-- <td valign="middle" background="../images/mail_leftbg.gif">
        &nbsp;
      </td>--%>
      <td valign="top" bgcolor="#F7F8F9">
        <div style="width: 98%; height: 30px; margin-top: 5px;">
          <table width="100%">
            <tr>
              <td align="left" width="100%">
                <table>
                  <tr>
                    <%-- <td>
                      <asp:Label ID="Label1" runat="server" Text="客户编码"></asp:Label>
                      <asp:TextBox ID="txtKHBM" runat="server" Width="60px"></asp:TextBox>
                      <asp:Label ID="Label5" runat="server" Text="客户名称"></asp:Label>
                      <asp:TextBox ID="txtKHMC" runat="server" Width="100px"></asp:TextBox>
                      <asp:Label ID="Label2" runat="server" Text="标识"></asp:Label>
                      <asp:TextBox ID="txtBS" runat="server" Width="70px"></asp:TextBox>
                    </td>--%>
                    <td>
                      <dxe:ASPxDateEdit ID="date1" runat="server" Width="90px">
                      </dxe:ASPxDateEdit>
                    </td>
                    <td>
                      <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="date1"
                        ErrorMessage="*"></asp:RequiredFieldValidator>
                    </td>
                    <td>
                      <dxe:ASPxDateEdit ID="date2" runat="server" Width="90px">
                      </dxe:ASPxDateEdit>
                    </td>
                    <td>
                      <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="date2"
                        ErrorMessage="*"></asp:RequiredFieldValidator>
                    </td>
                    <td>
                      <asp:Button ID="btnQuery" runat="server" Text="查询" OnClick="btnQuery_Click" />
                      <dxwgv:ASPxGridViewExporter ID="ASPxGridViewExporter1" runat="server" GridViewID="ASPxGridView1">
                      </dxwgv:ASPxGridViewExporter>
                      <asp:Button ID="Button1" runat="server" Text="导出excel" OnClick="btnExport_Click" />
                    </td>
                    <%--  <td>
                      <asp:RangeValidator ID="RangeValidator1" runat="server" ErrorMessage="客户编码必须为数字"
                        ControlToValidate="txtKHBM" MaximumValue="1000000000" MinimumValue="0" Type="Integer"></asp:RangeValidator>
                    </td>--%>
                  </tr>
                </table>
              </td>
              <%--<td align="right" width="30%">
              </td>--%>
            </tr>
          </table>
        </div>
        <div style="width: 98%;">
          <dxwgv:ASPxGridView ID="ASPxGridView1" runat="server" AutoGenerateColumns="False"
            KeyFieldName="xh" Width="100%" CssFilePath="~/App_Themes/Office2003 Blue/{0}/styles.css"
            CssPostfix="Office2003_Blue" Theme="Aqua">
            <SettingsBehavior AllowFocusedRow="True" AutoFilterRowInputDelay="-1" />
            <SettingsPager Mode="ShowPager" PageSize="12">
              <FirstPageButton Text="首页" Visible="True">
              </FirstPageButton>
              <LastPageButton Text="末页" Visible="True">
              </LastPageButton>
              <Summary Text="总页数 {1} 当前页 {0} (总记录 {2})" />
            </SettingsPager>
            <Styles CssFilePath="~/App_Themes/Office2003 Blue/{0}/styles.css" CssPostfix="Office2003_Blue">
              <Header ImageSpacing="5px" SortingImageSpacing="5px">
              </Header>
              <LoadingPanel ImageSpacing="10px">
              </LoadingPanel>
            </Styles>
            <Images ImageFolder="~/App_Themes/Office2003 Blue/{0}/">
              <FilterRowButton Height="13px" Width="13px" />
              <CollapsedButton Height="12px" Url="~/App_Themes/Office2003 Blue/GridView/gvCollapsedButton.png"
                Width="11px" />
              <ExpandedButton Height="12px" Url="~/App_Themes/Office2003 Blue/GridView/gvExpandedButton.png"
                Width="11px" />
              <DetailCollapsedButton Height="12px" Url="~/App_Themes/Office2003 Blue/GridView/gvCollapsedButton.png"
                Width="11px" />
              <DetailExpandedButton Height="12px" Url="~/App_Themes/Office2003 Blue/GridView/gvExpandedButton.png"
                Width="11px" />
            </Images>
            <Columns>
              <dxwgv:GridViewDataTextColumn Caption="序号" FieldName="xh" VisibleIndex="0" Width="50px"
                FixedStyle="Left">
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="客户编码" FieldName="KHID" VisibleIndex="1" Width="70px"
                FixedStyle="Left">
                <Settings AutoFilterCondition="Equals" />
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="客户名称" FieldName="KHMC" VisibleIndex="1" Width="200px"
                FixedStyle="Left">
                <Settings AutoFilterCondition="Contains" />
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="标识" FieldName="KH" VisibleIndex="1" Width="70px"
                FixedStyle="Left">
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="IC卡户" FieldName="IC" VisibleIndex="1" Width="55px">
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="用气性质" FieldName="YQXZ" VisibleIndex="1" Width="200px">
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="用气地址" FieldName="XXDZ" VisibleIndex="1" Width="250px">
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="本期实缴(元)" FieldName="BQSJ" VisibleIndex="1">
                <DataItemTemplate>
                  <asp:Label ID="Label3" runat="server" Text='<%#Eval("BQSJ").ToString()==""?"":string.Format("{0:n}", Convert.ToDecimal(Eval("BQSJ"))) %>'></asp:Label>
                </DataItemTemplate>
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="收费员" FieldName="XM" VisibleIndex="1">
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="收费时间" FieldName="SJ" VisibleIndex="1">
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="付款方式" FieldName="FKFS" VisibleIndex="1">
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="本期结余" FieldName="BCJYK" VisibleIndex="1">
                <DataItemTemplate>
                  <asp:Label ID="Label3" runat="server" Text='<%#Eval("BCJYK").ToString()==""?"":string.Format("{0:n}", Convert.ToDecimal(Eval("BCJYK"))) %>'></asp:Label>
                </DataItemTemplate>
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="" FieldName="" VisibleIndex="3">
                <DataItemTemplate>
                  <dxe:ASPxHyperLink ID="ASPxHyperLink3" runat="server" NavigateUrl='<%#Eval("ic").ToString()=="是"?"SSFGLExport.aspx?jfsjid="+ Eval("jfsjID")+"&khid="+Eval("khid"):"否"%>'
                    Text="查看" Target="_blank" />
                </DataItemTemplate>
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="" FieldName="" VisibleIndex="3">
                <DataItemTemplate>
                  <%--  <dxe:ASPxHyperLink ID="ASPxHyperLink3" runat="server" NavigateUrl='<%#"SSFGLAdd.aspx?khid="+Eval("khid")+"&jfsjid="+Eval("jfsjid")%>'
                    Text="编辑" />--%>
                  <a href="#" onclick="create2('<%#Eval("khid") %>','<%#Eval("jfsjid") %>');">编辑</a>
                </DataItemTemplate>
              </dxwgv:GridViewDataTextColumn>
              <%--<dxwgv:GridViewDataTextColumn Caption="本期结欠款" FieldName="BCJQK" VisibleIndex="1">
              </dxwgv:GridViewDataTextColumn>--%>
              <%--  --%>
              <%--  <dxwgv:GridViewDataTextColumn Caption="" FieldName="" VisibleIndex="11" Width="30px">
                <DataItemTemplate>
                  <asp:LinkButton ID="lbDelete" runat="server" CausesValidation="False" CommandName="Delete"
                    OnClientClick='<%#Eval("bqsj_sfsd").ToString()=="0"?"return confirm(\"是否删除?\")":""%>'
                    Enabled='<%#Eval("bqsj_sfsd").ToString()=="0"?true:false %>' Text="删除" CommandArgument='<%#DataBinder.Eval(Container.DataItem,"jfSJid") %>'
                    OnCommand="lbDelete_Command"></asp:LinkButton>
                </DataItemTemplate>
              </dxwgv:GridViewDataTextColumn>--%>
              <%-- <dxwgv:GridViewDataTextColumn Caption="" FieldName="" VisibleIndex="11" Width="40px">
                <DataItemTemplate>
                  <asp:LinkButton ID="lbSB" runat="server" CausesValidation="False" CommandName="SB"
                    Enabled='<%#Eval("bqsj_sfsd").ToString()=="0"?true:false %>' Text="锁定" CommandArgument='<%#DataBinder.Eval(Container.DataItem,"jfSJid") %>'
                    OnCommand="lbSB_Command"></asp:LinkButton>
                </DataItemTemplate>
              </dxwgv:GridViewDataTextColumn>--%>
            </Columns>
            <Settings ShowHorizontalScrollBar="True" UseFixedTableLayout="True" ShowFilterRow="true"
              ShowFilterRowMenu="true" ShowFooter="true" />
            <StylesEditors>
              <ProgressBar Height="25px">
              </ProgressBar>
            </StylesEditors>
            <TotalSummary>
              <dxwgv:ASPxSummaryItem FieldName="xh" SummaryType="Count" DisplayFormat="合计" />
              <dxwgv:ASPxSummaryItem FieldName="KHMC" SummaryType="Count" DisplayFormat="客户数量:{0}" />
              <dxwgv:ASPxSummaryItem FieldName="BQSJ" SummaryType="Sum" DisplayFormat="{0:n}" />
              <dxwgv:ASPxSummaryItem FieldName="BQJY" SummaryType="Sum" DisplayFormat="{0:n}" />
            </TotalSummary>
          </dxwgv:ASPxGridView>
        </div>
      </td>
      <%-- <td background="../images/mail_rightbg.gif">
        &nbsp;
      </td>--%>
    </tr>
    <%-- <tr>
      <td valign="bottom" background="../images/mail_leftbg.gif">
        <img src="../images/buttom_left2.gif" width="17" height="17" />
      </td>
      <td background="../images/buttom_bgs.gif">
        <img src="../images/buttom_bgs.gif" width="17" height="17">
      </td>
      <td valign="bottom" background="../images/mail_rightbg.gif">
        <img src="../images/buttom_right2.gif" width="16" height="17" />
      </td>
    </tr>--%>
  </table>
  </form>
  </form>
</body>
</html>
